2015-01-09 - 16460 - Spec - SL150-Add Corporate roll-up on pg1 #CrystalReportsSupport
SPECIFICATIONS
16460 - SL150 - Add Corporate roll-up on pg 1
Requirement Summary
Need to develop Regional versions for SL150.
Admin Info
Purpose
|
Need to develop Regional versions for SL150.
|
Requested By
|
Mark Harris
|
Spec Created By
|
Praveen Guntuka
|
Spec Created Date
|
01/09/2014
|
Spec QA by
|
Uday Kumar P
|
Objects
|
SL150
|
Document Status
|
Complete
|
Estimates
SNo
|
Activity
|
Estimation in Hours
|
1
|
Research
|
00
|
2
|
Documentation
|
08
|
3
|
Development/ Config
|
08
|
4
|
Unit test in DEV
|
04
|
5
|
Unit test in QUA
|
04
|
6
|
Other activity
|
00
|
|
TOTAL
|
24
|
References
Prior Tickets
None
Documents
None
Spec Changes
SNo.
|
Change Details
|
Requested By
|
Requested On
|
Notes if any
|
1
|
Add Corporate totals for each region
|
Mark G
|
01/12/2015
|
None
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Functional Requirement
Purpose/WHY:
Need to develop Regional versions for SL150.
In Scope:
SL150 report should be developed for all regions.
Out of Scope:
Other SL Reports.
Solution Summary
1. Need to create BEx Queries for all regions.
2. Need to move transports to BPQ & BPP.
3. Need to update the data sources in the reports for all regional versions.
4. Need to check if regional reports meet all the required changes specified by NEC.
Test Plan
Test ID
|
Test Scenario
|
Expected Results
|
1
|
Report Format.
|
Should be as per NEC crystal standard checklist.
|
2
|
Execute Crystal Report in Crystal Designer tool after changes.
|
Report should execute successfully in Crystal Designer tool.
|
3
|
Schedule the Report in NEC BI Launch Pad.
|
Report should execute successfully in NEC BI Launch Pad.
|
Solution Details
BW BEx Queries:
1. Need to create the new BEx Queries for all regions.
2. Need to create the open transport & collect all the required changes into the transport request.
3. Need to check if the BEx query meets the NEC Standards.
Crystal Development:
1. Need to update the data sources in the report for all regional versions.
2. Add a roll up to corporate (routing and non-routing) summary cross tab on page one.
3. For each region level, add region level totals in Cross tab.
4. Need to apply all formats & currency symbols for all regions as specified by NEC.
5. Japan Region particularly should display currency(in Yen) and font as Unicode MS.
6. After completion of development, the reports are saved and scheduled into the BOBJ Production Server.
7. Need to check if regional reports meet all the changes by NEC.
8. For the regional versions of this report, it should roll up routing and non-routing at the region level.
Issues
None